package com.vq3.digitalizationsoftwareintegrates.Mapper.User;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.vq3.digitalizationsoftwareintegrates.Entity.Spot_Check.S_C_DatesEntity;
import com.vq3.digitalizationsoftwareintegrates.Entity.User.User_RoleEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;


@Mapper
@DS("db01")
public interface User_RoleMapper extends BaseMapper<User_RoleEntity> {

    @Select("select * from user_role where user_id=#{uid} limit #{start},#{size}")
    List<User_RoleEntity> uidFindURole(@Param("uid") int uid, @Param("start") int start, @Param("size") int size);

    @Select("select * from user_role where urole_id=#{rid} limit #{start},#{size}")
    List<User_RoleEntity> ridFindUser(@Param("rid") int rid, @Param("start") int start, @Param("size") int size);
}
